package guoanmaker.operator.business.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import guoanmaker.operator.business.model.ProvideShop;


public interface ProvideShopRepository  extends JpaRepository<ProvideShop, String>, JpaSpecificationExecutor<ProvideShop> {
	
	
	@Query("select p from ProvideShop p left join  p.providerBusiness pb where  pb.id=:id ")
	public List<ProvideShop> findbyBusinessId(@Param("id") String id);

}
